2014-09-05 - 14244 - Spec - Service level data by day #SalesDistribution
SPECIFICATIONS
14244 - Service level data by day
Purpose
Need to pull Season Stock & Collection AC Performance Service level data by days late for 2014 June, July, and August 2014
Admin Info
Purpose
|
Service Level data by day.
|
Requested By
|
Kevin Boleware
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
09/05/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Service Level data
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
04
|
3
|
Development/Config
|
20
|
4
|
Unit test in DEV
|
00
|
5
|
Unit test in QUA
|
00
|
6
|
Formatting Changes
|
06
|
|
TOTAL
|
32
|
References
Prior Tickets
None
Documents
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to develop new crystal report for service level data by days.
In Scope:
Need to use excel Sheets in new report to show service level data by days.
Out of Scope:
None
Solution Summary
1. Need to use Excel Sheets in new report to show service level data by days.
2. Need to group data by Period and then by no of days late.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
4
|
Need to check the formatting of the excel sheet fields.
|
Formatting should be as per production reports.
|
Solution Details
1. Need to use Excel Sheets in new report to show service level data by days.
2. Need to use two groups i.e Period and No of days.
3. Need to show the service level data by days based on month group with irrespective of quantity.
4. Need to format the report to fit the data in page wise.
5. Need to change the restrictions and formulas that are using excel sheets.
5. Need to set the output to excel sheet.
Issues
None